Budget Group
|
Operating Budgets, Common Agricultural Examples
|
Budget
|
7- Corn and Soybean Same Year Machinery Stock Analysis
|
Costs
|
1252050.000 |
126206.000 |
66361.156 |
3380.915 |
71500.000 |
7700.000 |
149000.000 |
3300.000 |
268.000 |
238.000 |
12136.382 |
26.000 |
24547.380 |
2457.600 |
160.000 |
18935.970 |
48.505 |
113.000 |
245.649 |
35426.795 |
2340.000 |
1851.990 |
n.a.
|
79155.79 |
69742.07 |
|
|
|
|
|
60.000 |
809.487 |
|
53.748 |
|
112.000 |
1.200 |
4.000 |
34761.294 |
334.385 |
Time Period
|
Corn for Grain
|
Costs |
Market Value
|
Salvage Value
|
Cap Recov Cost
|
THI Cost
|
Starting Hrs
|
Planned Use Hrs
|
Useful Life Hrs
|
Horsepower
|
Speed
|
Width
|
Fuel Amount
|
Fuel Price
|
Fuel Cost
|
Labor Amount
|
Labor Price
|
Labor Cost
|
Lube Oil Amounts
|
Lube Oil Price
|
Lube Oil Cost
|
Repair Cost
|
Equiv PTO HP
|
Field Efficiency
|
Amount
|
Operating Cost
|
Alloc OH Cost
|
|
|
|
|
|
Labor Available (hours per day)
|
Area Covered (ac/ha per day)
|
Planned vs Actual Start Date
|
Probable Field Days Needed
|
Probable Finish Date
|
Timeliness Penalty Days From Start
|
Timeliness Penalty (percent)
|
Additional Penalty (percent)
|
Timeliness Penalty Cost (currency)
|
Timeliness Penalty Cost Per Hour
|
Operation
|
Chisel Plow
|
Input : Chisel Plow, Maximum 1 foot depth, Chisel or Sweep Type, Drawn or Mounted,
|
Costs
|
13100.00 |
1300.00 |
1350.4243 |
107.0977 |
1000 |
100 |
2000 |
140 |
5.0000 |
10.0000 |
0.0000 |
0.0000 |
0.0000 |
97.0000 |
0.00 |
0.0000 |
0.0000 |
5.0000 |
0.0000 |
944.5084 |
100 |
85.0000 |
0.1941 |
944.51 |
1457.52 |
|
|
|
|
|
Input : Tractor, 2-Wheel Drive, 190-220 PTO HP
|
Costs
|
116000.00 |
11000.00 |
2046.0695 |
188.5098 |
6000 |
500 |
12000 |
190 |
20.0000 |
10.0000 |
930.3367 |
2.0000 |
1860.6734 |
106.7000 |
12.00 |
1330.6072 |
4.4232 |
5.0000 |
22.9987 |
1780.1634 |
100 |
99.0000 |
0.1941 |
4994.44 |
2234.58 |
|
|
|
|
|
Operation
|
Plant, Corn Grain, medium tractor, Example 1
|
Input : Grain Drill, Most Common Spacing, Plain, 15-17 Openers
|
Costs
|
14000.00 |
1400.00 |
1919.2068 |
50.1480 |
750 |
200 |
1500 |
140 |
5.0000 |
14.0000 |
0.0000 |
0.0000 |
0.0000 |
92.4000 |
0.00 |
0.0000 |
0.0000 |
5.0000 |
0.0000 |
1033.2000 |
100 |
70.0000 |
0.1684 |
1033.20 |
1969.35 |
|
|
|
|
|
Input : Seed, grain
|
Input : Example 1- Tractor, New Calculators
|
Costs
|
53610.00 |
7566.00 |
1140.4344 |
51.3828 |
0 |
300 |
6000 |
140 |
5.0000 |
10.0000 |
697.3680 |
2.0000 |
1394.7360 |
92.4000 |
12.00 |
1108.8000 |
2.9484 |
3.0000 |
8.8536 |
208.0512 |
100 |
80.0000 |
0.1684 |
2720.44 |
1191.82 |
|
|
|
|
|
Operation
|
Apply Anyhdrous
|
Input : Tractor, 2-Wheel Drive, 140-159 PTO HP
|
Costs
|
84100.00 |
8400.00 |
319.7649 |
29.6982 |
6000 |
500 |
12000 |
150 |
20.0000 |
10.0000 |
238.3647 |
2.0000 |
495.4236 |
23.1000 |
12.00 |
288.0696 |
0.7812 |
5.0000 |
4.0635 |
279.4113 |
140 |
99.0000 |
0.0417 |
1066.97 |
349.46 |
|
|
|
|
|
Input : Anhydrous Applicator Rental
|
Input : Fertilizer, Anhydrous Ammonia
|
Operation
|
Field Cultivate
|
Input : Cultivator, Row Crop, 6 Row
|
Costs
|
6330.00 |
600.00 |
443.3475 |
18.6191 |
1000 |
200 |
2000 |
140 |
7.0000 |
10.0000 |
0.0000 |
0.0000 |
0.0000 |
69.5000 |
0.00 |
0.0000 |
0.0000 |
5.0000 |
0.0000 |
335.8588 |
100 |
85.0000 |
0.1387 |
335.86 |
461.97 |
|
|
|
|
|
Input : Tractor, 2-Wheel Drive, 140-159 PTO HP
|
Costs
|
84100.00 |
8400.00 |
1058.2696 |
98.2869 |
6000 |
500 |
12000 |
150 |
20.0000 |
10.0000 |
591.8829 |
2.0000 |
1183.7657 |
76.4500 |
12.00 |
953.3732 |
2.5854 |
5.0000 |
13.4483 |
924.7184 |
100 |
99.0000 |
0.1387 |
3075.31 |
1156.56 |
|
|
|
|
|
Operation
|
Weed Control, corn grain
|
Input : Sprayer, Field Crop, Power, Boom-Type, Tractor Mounted, w- 300 gallon Spray
|
Costs
|
5890.00 |
600.00 |
935.3858 |
24.5310 |
750 |
200 |
1500 |
140 |
6.5000 |
10.0000 |
0.0000 |
0.0000 |
0.0000 |
97.5000 |
0.00 |
0.0000 |
0.0000 |
5.0000 |
0.0000 |
501.5985 |
100 |
65.0000 |
0.1953 |
501.60 |
959.92 |
|
|
|
|
|
Input : Tractor, 2-Wheel Drive, 70-89 PTO HP
|
Costs
|
33600.00 |
3300.00 |
567.6353 |
12.7725 |
6000 |
500 |
12000 |
80 |
20.0000 |
10.0000 |
1260.0023 |
2.0000 |
2520.0045 |
97.5000 |
16.00 |
1606.1078 |
1.5015 |
5.0000 |
7.7123 |
489.9083 |
100 |
0.9900 |
0.1953 |
4623.73 |
580.41 |
|
|
|
|
|
Input : EPTC (Eptan), 7E-(Eradicane), 6-7#-GAL EC
|
Operation
|
Combine, corn grain
|
Costs
|
159000.000 |
16000.000 |
20868.929 |
885.704 |
1500.000 |
300.000 |
3000.000 |
140.000 |
3.000 |
10.000 |
1631.343 |
2.000 |
3390.647 |
216.150 |
12.000 |
2695.508 |
6.897 |
5.000 |
35.861 |
8799.506 |
100.000 |
70.000 |
n.a.
|
14921.52 |
21754.63 |
|
|
|
|
|
10.000 |
89.286 |
10/01/2003
---10/01/2003 |
7.000 |
10/07/2003 |
21.000 |
0.100 |
0.500 |
0.000 |
0.000 |
Input : Combine, Self Propelled with Grain Head, Large capacity
|
Costs
|
159000.00 |
16000.00 |
20868.9288 |
885.7041 |
1500 |
300 |
3000 |
140 |
3.0000 |
10.0000 |
1631.3430 |
2.0000 |
3390.6468 |
216.1500 |
12.00 |
2695.5084 |
6.8972 |
5.0000 |
35.8613 |
8799.5058 |
100 |
70.0000 |
0.3929 |
14921.52 |
21754.63 |
|
|
|
|
|
Operation
|
Haul, corn grain
|
Costs
|
68000.000 |
6780.000 |
2341.702 |
158.915 |
6750.000 |
700.000 |
13500.000 |
280.000 |
25.000 |
20.000 |
1054.354 |
2.000 |
2108.708 |
266.700 |
12.000 |
1742.135 |
4.458 |
10.000 |
23.178 |
1853.883 |
200.000 |
164.000 |
n.a.
|
5727.90 |
2500.62 |
|
|
|
|
|
10.000 |
166.667 |
10/01/2003
---10/01/2003 |
3.750 |
10/04/2003 |
21.000 |
0.100 |
0.500 |
0.000 |
0.000 |
Input : Tractor, 2-Wheel Drive, 110-129 PTO HP
|
Costs
|
63800.00 |
6380.00 |
1466.8881 |
136.2583 |
6000 |
500 |
12000 |
140 |
20.0000 |
10.0000 |
1054.3540 |
2.0000 |
2108.7080 |
139.7000 |
12.00 |
1742.1352 |
4.4577 |
5.0000 |
23.1775 |
1281.8999 |
100 |
99.0000 |
0.2538 |
5155.92 |
1603.15 |
|
|
|
|
|
Input : Wagon, Gravity Unload, w- Box and Running, Gear, and Tires, 200-400 bu, w-0
|
Costs
|
4200.00 |
400.00 |
874.8141 |
22.6568 |
750 |
200 |
1500 |
140 |
5.0000 |
10.0000 |
0.0000 |
0.0000 |
0.0000 |
127.0000 |
0.00 |
0.0000 |
0.0000 |
5.0000 |
0.0000 |
571.9826 |
100 |
65.0000 |
0.2538 |
571.98 |
897.47 |
|
|
|
|
|
Time Period Totals
|
Time Period
|
Soybeans for Grain
|
Costs |
Market Value
|
Salvage Value
|
Cap Recov Cost
|
THI Cost
|
Starting Hrs
|
Planned Use Hrs
|
Useful Life Hrs
|
Horsepower
|
Speed
|
Width
|
Fuel Amount
|
Fuel Price
|
Fuel Cost
|
Labor Amount
|
Labor Price
|
Labor Cost
|
Lube Oil Amounts
|
Lube Oil Price
|
Lube Oil Cost
|
Repair Cost
|
Equiv PTO HP
|
Field Efficiency
|
Amount
|
Operating Cost
|
Alloc OH Cost
|
|
|
|
|
|
Labor Available (hours per day)
|
Area Covered (ac/ha per day)
|
Planned vs Actual Start Date
|
Probable Field Days Needed
|
Probable Finish Date
|
Timeliness Penalty Days From Start
|
Timeliness Penalty (percent)
|
Additional Penalty (percent)
|
Timeliness Penalty Cost (currency)
|
Timeliness Penalty Cost Per Hour
|
Operation
|
Chisel Plow
|
Input : Chisel Plow, Maximum 1 foot depth, Chisel or Sweep Type, Drawn or Mounted,
|
Costs
|
13100.00 |
1300.00 |
1350.4243 |
107.0977 |
1000 |
100 |
2000 |
140 |
5.0000 |
10.0000 |
0.0000 |
0.0000 |
0.0000 |
97.0000 |
0.00 |
0.0000 |
0.0000 |
5.0000 |
0.0000 |
944.5084 |
100 |
85.0000 |
0.1941 |
944.51 |
1457.52 |
|
|
|
|
|
Input : Tractor, 2-Wheel Drive, 190-220 PTO HP
|
Costs
|
116000.00 |
11000.00 |
2046.0695 |
188.5098 |
6000 |
500 |
12000 |
190 |
20.0000 |
10.0000 |
930.3367 |
2.0000 |
1860.6734 |
106.7000 |
12.00 |
1330.6072 |
4.4232 |
5.0000 |
22.9987 |
1780.1634 |
100 |
99.0000 |
0.1941 |
4994.44 |
2234.58 |
|
|
|
|
|
Operation
|
Seeding and Planting, soybeans
|
Input : Seed, soybeans
|
Input : Grain Drill, Most Common Spacing, Plain, 15-17 Openers
|
Costs
|
14000.00 |
1400.00 |
1919.2068 |
50.1480 |
750 |
200 |
1500 |
140 |
5.0000 |
14.0000 |
0.0000 |
0.0000 |
0.0000 |
92.4000 |
0.00 |
0.0000 |
0.0000 |
5.0000 |
0.0000 |
1033.2000 |
100 |
70.0000 |
0.1684 |
1033.20 |
1969.35 |
|
|
|
|
|
Input : Tractor, 2-Wheel Drive, 140-159 PTO HP
|
Costs
|
84100.00 |
8400.00 |
1279.0596 |
118.7928 |
6000 |
500 |
12000 |
150 |
20.0000 |
10.0000 |
715.3692 |
2.0000 |
1430.7384 |
92.4000 |
12.00 |
1152.2784 |
3.1248 |
5.0000 |
16.2540 |
1117.6452 |
100 |
99.0000 |
0.1684 |
3716.92 |
1397.85 |
|
|
|
|
|
Operation
|
Field Cultivate
|
Input : Cultivator, Row Crop, 6 Row
|
Costs
|
6330.00 |
600.00 |
443.3475 |
18.6191 |
1000 |
200 |
2000 |
140 |
7.0000 |
10.0000 |
0.0000 |
0.0000 |
0.0000 |
69.5000 |
0.00 |
0.0000 |
0.0000 |
5.0000 |
0.0000 |
335.8588 |
100 |
85.0000 |
0.1387 |
335.86 |
461.97 |
|
|
|
|
|
Input : Tractor, 2-Wheel Drive, 140-159 PTO HP
|
Costs
|
84100.00 |
8400.00 |
1058.2696 |
98.2869 |
6000 |
500 |
12000 |
150 |
20.0000 |
10.0000 |
591.8829 |
2.0000 |
1183.7657 |
76.4500 |
12.00 |
953.3732 |
2.5854 |
5.0000 |
13.4483 |
924.7184 |
100 |
99.0000 |
0.1387 |
3075.31 |
1156.56 |
|
|
|
|
|
Operation
|
Weed Control, soybeans
|
Input : Glyphosate (Roundup), 4#-GAL EC, 2003
|
Input : Sprayer, Field Crop, Power, Boom-Type, Tractor Mounted, w- 300 gallon Spray
|
Costs
|
5890.00 |
600.00 |
936.8248 |
24.5687 |
750 |
200 |
1500 |
140 |
6.5000 |
10.0000 |
0.0000 |
0.0000 |
0.0000 |
97.6500 |
0.00 |
0.0000 |
0.0000 |
5.0000 |
0.0000 |
502.3702 |
100 |
65.0000 |
0.1953 |
502.37 |
961.39 |
|
|
|
|
|
Input : Tractor, 2-Wheel Drive, 110-129 PTO HP
|
Costs
|
63800.00 |
6380.00 |
1126.1543 |
104.6078 |
6000 |
500 |
12000 |
140 |
20.0000 |
10.0000 |
809.4450 |
2.0000 |
1618.8900 |
107.2500 |
12.00 |
1337.4660 |
3.4223 |
5.0000 |
17.7938 |
984.1358 |
100 |
99.0000 |
0.1953 |
3958.29 |
1230.76 |
|
|
|
|
|
Operation
|
Combine, soybeans
|
Input : Combine, Self Propelled with Grain Head, Large capacity
|
Costs
|
159000.00 |
16000.00 |
20868.9288 |
885.7041 |
1500 |
300 |
3000 |
140 |
3.0000 |
10.0000 |
1631.3430 |
2.0000 |
3390.6468 |
216.1500 |
12.00 |
2695.5084 |
6.8972 |
5.0000 |
35.8613 |
8799.5058 |
100 |
70.0000 |
0.3929 |
14921.52 |
21754.63 |
|
|
|
|
|
Operation
|
Haul beans, soybean
|
Input : Tractor, 2-Wheel Drive, 110-129 PTO HP
|
Costs
|
63800.00 |
6380.00 |
1466.8881 |
136.2583 |
6000 |
500 |
12000 |
140 |
20.0000 |
10.0000 |
1054.3540 |
2.0000 |
2108.7080 |
139.7000 |
12.00 |
1742.1352 |
4.4577 |
5.0000 |
23.1775 |
1281.8999 |
100 |
99.0000 |
0.2538 |
5155.92 |
1603.15 |
|
|
|
|
|
Input : Wagon, Gravity Unload, w- Box and Running, Gear, and Tires, 200-400 bu, w-0
|
Costs
|
4200.00 |
400.00 |
874.8141 |
22.6568 |
750 |
200 |
1500 |
140 |
5.0000 |
10.0000 |
0.0000 |
0.0000 |
0.0000 |
127.0000 |
0.00 |
0.0000 |
0.0000 |
5.0000 |
0.0000 |
571.9826 |
100 |
65.0000 |
0.2538 |
571.98 |
897.47 |
|
|
|
|
|
Time Period Totals
|